﻿CREATE TABLE [dbo].[DrinkOrder] (
    [DrinkOrderId] INT           IDENTITY (1, 1) NOT NULL,
    [TableOrderId] INT           NOT NULL,
    [DrinkId]      INT           NOT NULL,
    [Quantity]     INT           NOT NULL,
    [Note]         NVARCHAR (50) NULL,
    [IsDeleted]    BIT           NOT NULL,
    [Created]      DATETIME      NULL,
    CONSTRAINT [PK_DrinksOrder] PRIMARY KEY CLUSTERED ([DrinkOrderId] ASC),
    CONSTRAINT [FK_DrinksOrder_Drinks] FOREIGN KEY ([DrinkId]) REFERENCES [dbo].[Drinks] ([DrinkId]),
    CONSTRAINT [FK_DrinksOrder_TableOrder] FOREIGN KEY ([TableOrderId]) REFERENCES [dbo].[TableOrder] ([TableOrderId])
);



